{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Navigation Pane","General Input Sheet","Existing Trunk Assets - LFCF","Future Trunk Assets - LFCF","Catchment Demand - LFCF","Summary Cost Schedule"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Navigation Pane","index":0,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,15],[2,1,2,15],[3,5,3,6],[11,7,11,10],[12,7,22,10],[11,12,11,15],[9,3,9,4],[9,8,9,9],[9,13,9,14],[11,2,11,5],[12,2,12,5],[14,2,14,5],[15,2,15,5],[12,12,12,15],[7,3,8,15],[15,12,15,15],[17,2,17,5],[14,12,14,15],[22,2,22,5],[21,2,21,5],[18,2,18,5],[20,2,20,5]]}
[]
[null,"Brisbane City Council"]
[null,"Local Government Infrastructure Plan (LGIP)"]
[]
[]
[null,"Version No",null,1,null,"Date","2022-11-01",null,null,"Author ","BCC",null,null,null,null,null," "]
[]
[null,"Comments",null,"Draft LGIP 1B - Land for Community Facilities - Schedule of Works model "]
[]
[null,null,null,"Inputs",null,null,null,null,"Calculation",null,null,null,null,"Outputs"]
[]
[null,null,"General Input Sheet",null,null,null,null,"Calculation Function",null,null,null,null,"Summary Cost Schedule",null,null,null,null," "]
[null,null,"l Financial Inputs\nl Other \"generic\" inputs",null,null,null,null,"Catchment based summary of demand, infrastructure (existing and new) and cost allocation\n\nInfrastructure Cost calculation for each catchment\n\nOptional Discounted Cashflow",null,null,null,null,"l Summary of demand and cost allocation by catchment \nl Final costs by catchment",null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summary Cash flow Projections"]
[null,null,"l Unit Cost of Passive Assets\nl Unit Cost of Land",null,null,null,null,null,null,null,null,null,"l Summary of forecast Cap X and anticipated IC revenues. Refer to Revenue and Cash Flow model for output."]
[]
[]
[null,null,"l Estimates of current and future demand (per cost catchment)",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,"Asset Inputs"]

{"sheet":"General Input Sheet","index":1,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[[1,1,1,11],[3,1,3,10],[24,1,29,1],[20,1,22,1],[5,1,5,2],[15,1,15,2],[11,1,11,2]]}
[]
[null,{"$f":"'Navigation Pane'!B2","v":"Brisbane City Council"}]
["Return to Navigation Pane"]
[null,"General Input Sheet"]
[]
[null,"General Inputs",null,null,"Reference",null,"Value",null,"Comments"]
[]
[null,null,"Base Year",null,"YEAR",null,2021]
[null,null,null,null,null,null,{"$f":"YEAR","v":2021}]
[null,null,"Term (between 15 and 30 years)",null,"TERM",null,15]
[]
[null,"Application of Discounted Cash flow"]
[null,null," "]
[null,null,"Calculate charges using Discounted Cash flow? (Y/N)",null,"DCFTRIGGER",null,"Yes"]
[]
[null,"General Financial Inputs"]
[]
[null,"Discount Rate (WACC):"]
[null,null,"Average 10 Year Bond Rate",null,"TenYr"]
[]
[null,"Option 1 ","Basic Margin on 10 Yr. Bond Rate",null,"Margin",null,null,null,"3.5% is the baseline figure quoted in LG Bulletin 06/01"]
[]
[null,null,"WACC:",null,"WACC1",null,5.91E-2]
[]
[null,"Option 2","Capital Structure (% Debt)",null,"Capstr"]
[null,null,"Market Risk Premium",null,"Risk"]
[null,null,"Asset Beta",null,"AssetBeta"]
[null,null,"Cost of Debt",null,"Debt"]
[]
[null,null,"WACC:",null,"WACC2",null,5.91E-2]
[]
[null,null,"WACC Option to be applied in the calculation?",null,"WACC1",null,{"$f":"IF(G14=\"No\",0,IF(E32=\"WACC1\",WACC1,IF(E32=\"WACC2\",WACC2,\"Error\")))","v":5.91E-2}]
[]
[null,"Escalation Rates"]
[null,null,"Capital Escalation - Future Cap X",null,"PPI",null,1.8200000000000001E-2,null,"ten (10) yr. average Roads and Bridges Index (ABS 6427, Table 15, Index 3101)"]
[]
[null,null,"Capital Indexation Rates - Historical (June Qtr.)"]
[null,null,null,null,{"$f":"YEAR","v":2021},null,119.78,null,"Roads and Bridges Index (ABS 6427, Table 15, Index 3101)"]
[null,null,null,null,{"$f":"E38-1","v":2020},null,118.02]
[null,null,null,null,{"$f":"E39-1","v":2019},null,114.56]
[null,null,null,null,2018,null,112.03]
[null,null,null,null,{"$f":"E41-1","v":2017},null,110.64]
[null,null,null,null,{"$f":"E42-1","v":2016},null,110.54]
[null,null,null,null,{"$f":"E43-1","v":2015}]
[null,null,null,null,2014]
[null,null,null,null,2013]
[null,null,null,null,2012]
[null,null,null,null,2011,null,100.0076]
[]
[]
[null,null,"Land Escalation",null,"LandInd",null,{"$f":"(G53/G63)^(1/(E53-E63))-1","v":2.0111853187589457E-2},null,"ten (10) yr. average Consumer Price Index Roads between 2011 - 2021  (Mar Qtr.)"]
[]
[null,null,null,null,{"$f":"YEAR","v":2021},null,117.52844863116896,null,"three (3) yr. rolling average Consumer Price Index (ABS 6427, Table 17, Index 3101, Series ID: A2333727L)"]
[null,null,null,null,{"$f":"E53-1","v":2020}]
[null,null,null,null,{"$f":"E54-1","v":2019}]
[null,null,null,null,2018]
[null,null,null,null,{"$f":"E56-1","v":2017}]
[null,null,null,null,{"$f":"E57-1","v":2016},null,108.28580733223882]
[null,null,null,null,{"$f":"E58-1","v":2015}]
[null,null,null,null,2014]
[null,null,null,null,2013]
[null,null,null,null,2012]
[null,null,null,null,2011,null,96.308598892127009]
[]
[null,null,null,null,null,null,{"$f":"Chargeind","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"Chargeind","v":{"$error":"#REF!"}}]

{"sheet":"Existing Trunk Assets - LFCF","index":2,"n_rows":93,"n_cols":34,"rows_kept":93,"cut":false,"hidden":false,"merged":[[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,23,9,23],[8,24,9,24],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,29,9,29],[0,1,0,24],[1,1,1,24],[3,1,3,24],[8,22,9,22],[5,1,5,2],[7,16,7,20],[8,1,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,12],[8,13,8,15],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20]]}
[null,{"$f":"'Navigation Pane'!B2","v":"Brisbane City Council"}]
[null,"Land for Community Facilities"]
["Return to \"Existing Trunk Assets\""]
[null,"EXISTING TRUNK ASSETS"]
[]
[null,"Land Valuation Type",null,"Location"]
[]
[null,null,null,null,null,null,null,"Asset Data",null,null,null,null,null,null,null,null,"Catchment Asset Allocation",null,null,null,null,null,null,"Asset Usage",null,null,null,null,null,null,"Cost Allocation"]
[null,"Basic Asset Data",null,null,null,null,"Asset Attributes",null,"Basic Asset Valuation",null,null,null,null,"Refined Asset Value",null,null,"Fringe","Urban East","Urban North","Urban South","Urban West",null,{"$f":"Q9","v":"Fringe"},{"$f":"R9","v":"Urban East"},{"$f":"S9","v":"Urban North"},{"$f":"T9","v":"Urban South"},{"$f":"U9","v":"Urban West"},"TOTALS",null,{"$f":"Q9","v":"Fringe"},{"$f":"R9","v":"Urban East"},{"$f":"S9","v":"Urban North"},{"$f":"T9","v":"Urban South"},{"$f":"U9","v":"Urban West"}]
[null,"Asset ID","LGIP ID","Asset Class","Service Catchment","Description","Utility allowance ($56,000/site)","Area size (m2)","Construction Unit Rate ($/m)","Construction Cost","Size of land (m2) (*)","Land Unit Rate ($/m2)","Land Value","Valuation Year","Escalation","Current Repalcement Cost","Fringe","Urban East","Urban North","Urban South","Urban West"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"Q11+1","v":2},{"$f":"R11+1","v":3},4,5]
[null,"Councils ID (from GIS, FAR, AMA etc.)","ID from the LGIP drawings","Local/District",null,null,null,null,null,"May be calculated from unit rates OR unique values can be direct entered",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q9,Parkscatch,6,FALSE),\"\")","v":21245},331019,508114,486037,287882,null,null,null,null,null,null,null,null,{"$f":"SUM(AD13:AD92)","v":0},{"$f":"SUM(AE13:AE92)","v":73946878.701298699},{"$f":"SUM(AF13:AF92)","v":509010309.09162354},{"$f":"SUM(AG13:AG92)","v":93917782.282226384},{"$f":"SUM(AH13:AH92)","v":34607871.502978802}]
[null,"PCF192","EXIT-CF-107","District","Urban South","AUSTRALIAN PENSIONERS & SUPERANNUANTS LEAGUE QUEENSLAND",56000,800,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":92000},800,2046.7532467532469,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1637402.5974025975},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N13,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},{"$f":"J13+M13*Table156[[#This Row],[Escalation]]","v":1729402.5974025975},{"$f":"IF(Q$9=$E13,\"y\",\"\")","v":""},{"$f":"IF(R$9=$E13,\"y\",\"\")","v":""},"","y","",null,{"$f":"IF(Q13=\"y\",100%,\"\")","v":""},{"$f":"IF(R13=\"y\",100%,\"\")","v":""},"",1,"",{"$f":"SUM(W13:AA13)","v":1},null,{"$f":"IF(W13=\"\",\"\",(W13/$AB13)*$P13)","v":""},"","",1729402.5974025975,""]
[null,"PCF192","EXIT-CF-108","District","Urban South","WEST END LIBRARY",56000,800,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":92000},800,2046.7532467532469,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1637402.5974025975},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N14,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},{"$f":"J14+M14","v":1729402.5974025975},{"$f":"IF(Q$9=$E14,\"y\",\"\")","v":""},"","","y","",null,{"$f":"IF(Q14=\"y\",100%,\"\")","v":""},{"$f":"IF(R14=\"y\",100%,\"\")","v":""},{"$f":"IF(S14=\"y\",100%,\"\")","v":""},{"$f":"IF(T14=\"y\",100%,\"\")","v":1},{"$f":"IF(U14=\"y\",100%,\"\")","v":""},{"$f":"SUM(W14:AA14)","v":1},null,{"$f":"IF(W14=\"\",\"\",(W14/$AB14)*$P14)","v":""},{"$f":"IF(X14=\"\",\"\",(X14/$AB14)*$P14)","v":""},{"$f":"IF(Y14=\"\",\"\",(Y14/$AB14)*$P14)","v":""},{"$f":"IF(Z14=\"\",\"\",(Z14/$AB14)*$P14)","v":1729402.5974025975},{"$f":"IF(AA14=\"\",\"\",(AA14/$AB14)*$P14)","v":""}]
[null,"PCF53","EXIT-CF-109a","District","Urban North","Bracken Ridge Hall",56000,1300,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":114500},1300,2046.7532467532469,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":2660779.220779221},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N15,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},2775279.220779221,"","","y","","",null,"","",1,"","",1,null,"","",2775279.220779221,"",""]
[null,"PCF53","EXIT-CF-109b","District","Urban North","BRACKEN RIDGE LIBRARY",56000,3400,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":209000},3400,1228.0519480519481,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":4175376.6233766237},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N16,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},4384376.6233766237,"","","y","","",null,"","",1,"","",1,null,"","",4384376.6233766237,"",""]
[null,"PCF54","EXIT-CF-110a","Local","Urban North","Sandgate Hall",56000,900,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":96500},900,1228.0519480519481,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1105246.7532467532},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N17,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1201746.7532467532,"","","y","","",null,"","",1,"","",1,null,"","",1201746.7532467532,"",""]
[null,"PCF54","EXIT-CF-110b","District","Urban North","SANDGATE LIBRARY",56000,300,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":69500},300,1023.3766233766235,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":307012.98701298703},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N18,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},376512.98701298703,"","","y","","",null,"","",1,"","",1,null,"","",376512.98701298703,"",""]
[null,"PCF172","EXIT-CF-111","District","Urban West","ITHACA POOL",56000,2067,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":149015},2067,1228.0519480519481,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":2538383.3766233767},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N19,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},2687398.3766233767,"","","","","y",null,"","","","",1,1,null,"","","","",2687398.3766233767]
[null,"PCF129","EXIT-CF-112","Local","Urban West","UPPER KEDRON (CEDAR CREEK) HALL BUILDING",56000,1500,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":123500},1500,1228.0519480519481,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1842077.9220779222},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N20,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1965577.9220779222,"","","","","y",null,"","","","",1,1,null,"","","","",1965577.9220779222]
[null,"PCF254","EXIT-CF-115","District","Urban East","MT GRAVATT LIBRARY",56000,900,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":96500},900,1023.3766233766235,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":921038.96103896108},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N21,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1017538.9610389611,"","y","","","",null,"",1,"","","",1,null,"",1017538.9610389611,"","",""]
[null,"PCF212","EXIT-CF-120","District","Urban South","FAIRFIELD LIBRARY",56000,500,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":78500},500,1023.3766233766235,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":511688.31168831175},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N22,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},590188.31168831175,"","","","y","",null,"","","",1,"",1,null,"","","",590188.31168831175,""]
[null,"PCF177","EXIT-CF-122a","District","Urban East","WYNNUM LIBRARY",56000,2300,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":159500},2300,1228.0519480519481,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":2824519.4805194805},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N23,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},2984019.4805194805,"","y","","","",null,"",1,"","","",1,null,"",2984019.4805194805,"","",""]
[null,"PCF177","EXIT-CF-122b","District","Urban East","WYNNUM COMMUNITY CENTRE BUILDING A",56000,4600,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":263000},4600,1535.0649350649353,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":7061298.7012987025},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N24,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},7324298.7012987025,"","y","","","",null,"",1,"","","",1,null,"",7324298.7012987025,"","",""]
[null,"PCF252","EXIT-CF-123a","Local","Urban South","MOOROOKA COMMUNITY HALL BUILDING",56000,2000,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":146000},2000,1194.6030623073427,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":2389206.1246146853},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N25,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},2535206.1246146853,"","","","y","",null,"","","",1,"",1,null,"","","",2535206.1246146853,""]
[null,"PCF252","EXIT-CF-123b","District","Urban South","Spinal Home Help Inc.",56000,600,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":83000},600,1194.6030623073427,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":716761.83738440566},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N26,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},799761.83738440566,"","","","y","",null,"","","",1,"",1,null,"","","",799761.83738440566,""]
[null,"PCF294","EXIT-CF-126","District","Urban South","RUNCORN POOL",56000,12666,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":625970},12666,1279.2207792207794,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":16202610.389610391},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N27,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},16828580.389610391,"","","","y","",null,"","","",1,"",1,null,"","","",16828580.389610391,""]
[null,"PCF133","EXIT-CF-128","District","Urban North","KEDRON SUBSTATION BUILDING",56000,500,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":78500},500,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1279220.7792207794},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N28,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1357720.7792207794,"","","y","","",null,"","",1,"","",1,null,"","",1357720.7792207794,"",""]
[null,"PCF213","EXIT-CF-132","District","Urban South","STONES CORNER LIBRARY",56000,1600,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":128000},1600,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":4093506.493506494},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N29,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},4221506.493506494,"","","","y","",null,"","","",1,"",1,null,"","","",4221506.493506494,""]
[null,"PCF230","EXIT-CF-133","District","Urban West","Jindalee Swimming Pool",56000,5094,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":285230},5094,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":13032701.298701301},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N30,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},13317931.298701301,"","","","","y",null,"","","","",1,1,null,"","","","",13317931.298701301]
[null,"PCF93","EXIT-CF-136","Local","Urban North","ZILLMERE COMMUNITY HALL BUILDING",56000,600,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":83000},600,1535.0649350649353,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":921038.96103896119},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N31,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1004038.9610389612,"","","y","","",null,"","",1,"","",1,null,"","",1004038.9610389612,"",""]
[null,"PCF273","EXIT-CF-138","District","Urban South","COOPERS PLAINS LIBRARY",56000,8100,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":420500},8100,990.57139644229665,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":8023628.3111826032},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N32,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},8444128.3111826032,"","","","y","",null,"","","",1,"",1,null,"","","",8444128.3111826032,""]
[null,"PCF290","EXIT-CF-140","District","Urban South","KYABRA COMMUNITY ASSOCIATION INC.",56000,200,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":65000},200,1228.0519480519481,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":245610.38961038963},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N33,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},310610.3896103896,"","","","y","",null,"","","",1,"",1,null,"","","",310610.3896103896,""]
[null,"PCF114","EXIT-CF-141","Local","Urban North","NORTHGATE COMMUNITY HALL BUILDING",56000,1200,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":110000},1200,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":3070129.8701298707},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N34,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},3180129.8701298707,"","","y","","",null,"","",1,"","",1,null,"","",3180129.8701298707,"",""]
[null,"PCF232","EXIT-CF-142","District","Urban South","Kindergarten",56000,2000,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":146000},2000,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":5116883.1168831177},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N35,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},5262883.1168831177,"","","","y","",null,"","","",1,"",1,null,"","","",5262883.1168831177,""]
[null,"PCF234","EXIT-CF-143","District","Urban East","HOLLAND PARK LIBRARY",56000,4400,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":254000},4400,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":11257142.857142858},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N36,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},11511142.857142858,"","y","","","",null,"",1,"","","",1,null,"",11511142.857142858,"","",""]
[null,"PCF309","EXIT-CF-149","District","Urban South","CAROLE PARK SWIMMING POOL",56000,5513,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":304085},5513,1279.2207792207794,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":7052344.1558441566},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N37,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},7356429.1558441566,"","","","y","",null,"","","",1,"",1,null,"","","",7356429.1558441566,""]
[null,"PCF193","EXIT-CF-151","District","Urban East","Metro Arts Ltd.",56000,400,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":74000},400,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1023376.6233766235},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N38,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1097376.6233766235,"","y","","","",null,"",1,"","","",1,null,"",1097376.6233766235,"","",""]
[null,"PCF93","EXIT-CF-153","District","Urban North","ZILLMERE LIBRARY",56000,1000,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":101000},1000,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":2558441.5584415589},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N39,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},2659441.5584415589,"","","y","","",null,"","",1,"","",1,null,"","",2659441.5584415589,"",""]
[null,"PCF192","EXIT-CF-156a","District","Urban North","CITY HALL BUILDING - rooms",56000,8500,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":438500},8500,12280.519480519482,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":104384415.5844156},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N40,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},104822915.5844156,"","","y","","",null,"","",1,"","",1,null,"","",104822915.5844156,"",""]
[null,"PCF192","EXIT-CF-156b","Principal","Urban North","CITY HALL BUILDING - Museum of Brisbane",0,8500,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":382500},8500,12280.519480519482,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":104384415.5844156},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N41,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},104766915.5844156,"","","y","","",null,"","",1,"","",1,null,"","",104766915.5844156,"",""]
[null,"PCF192","EXIT-CF-156c","Principal","Urban North","CITY HALL BUILDING - stage",0,8500,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":382500},8500,12280.519480519482,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":104384415.5844156},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N42,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},104766915.5844156,"","","y","","",null,"","",1,"","",1,null,"","",104766915.5844156,"",""]
[null,"PCF249","EXIT-CF-158a","District","Urban West","MT OMMANEY LIBRARY",56000,1000,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":101000},1000,1228.0519480519481,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1228051.9480519481},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N43,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1329051.9480519481,"","","","","y",null,"","","","",1,1,null,"","","","",1329051.9480519481]
[null,"PCF215","EXIT-CF-162","Principal","Urban East","CARINDALE LIBRARY",56000,1989,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":145505},1989,1535.0649350649353,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":3053244.1558441562},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N44,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},3198749.1558441562,"","y","","","",null,"",1,"","","",1,null,"",3198749.1558441562,"","",""]
[null,"PCF209","EXIT-CF-166","District","Urban West","KENMORE LIBRARY",56000,1600,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":128000},1600,1023.3766233766235,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1637402.5974025975},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N45,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1765402.5974025975,"","","","","y",null,"","","","",1,1,null,"","","","",1765402.5974025975]
[null,"PCF254","EXIT-CF-170a","District","Urban East","Hibiscus Swimming Pool",56000,11474,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":572330},11474,1228.0519480519481,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":14090668.051948052},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N46,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},14662998.051948052,{"$f":"IF(Q$9=$E46,\"y\",\"\")","v":""},"y","","","",null,"",1,"","","",1,null,"",14662998.051948052,"","",""]
[null,"PCF254","EXIT-CF-170b","Principal","Urban East","Hibiscus Sports Complex",56000,12335,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":611075},12335,102.33766233766235,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1262335.0649350651},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N47,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1873410.0649350651,"","y","","","",null,"",1,"","","",1,null,"",1873410.0649350651,"","",""]
[null,"PCF192","EXIT-CF-171","Metro","Urban North","BRISBANE SQUARE LIBRARY",56000,4600,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":263000},4600,12280.519480519482,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":56490389.61038962},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N48,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},56753389.61038962,"","","y","","",null,"","",1,"","",1,null,"","",56753389.61038962,"",""]
[null,"PCF291","EXIT-CF-176a","District","Urban South","Inala Arts",56000,800,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":92000},800,1228.0519480519481,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":982441.5584415585},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N49,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1074441.5584415584,"","","","y","",null,"","","",1,"",1,null,"","","",1074441.5584415584,""]
[null,"PCF291","EXIT-CF-176b","District","Urban South","INALA ART GALLERY BUILDING",56000,200,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":65000},200,1023.3766233766235,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":204675.32467532469},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N50,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},269675.32467532472,"","","","y","",null,"","","",1,"",1,null,"","","",269675.32467532472,""]
[null,"PCF291","EXIT-CF-176c","District","Urban South","INALA LIBRARY",56000,800,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":92000},800,1023.3766233766235,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":818701.29870129877},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N51,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},910701.29870129877,"","","","y","",null,"","","",1,"",1,null,"","","",910701.29870129877,""]
[null,"PCF313","EXIT-CF-178","Principal","Urban South","SUNNYBANK HILLS LIBRARY",56000,1700,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":132500},1700,1228.0519480519481,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":2087688.3116883119},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N52,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},2220188.3116883119,"","","","y","",null,"","","",1,"",1,null,"","","",2220188.3116883119,""]
[null,"PCF93","EXIT-CF-181","District","Urban North","NORTH EAST COMMUNITY SUPPORT GROUP INC.",56000,1700,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":132500},1700,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":4349350.6493506497},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N53,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},4481850.6493506497,"","","y","","",null,"","",1,"","",1,null,"","",4481850.6493506497,"",""]
[null,"PCF174","EXIT-CF-185","District","Urban East","BULIMBA LIBRARY",56000,1500,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":123500},1500,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":3837662.3376623383},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N54,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},3961162.3376623383,"","y","","","",null,"",1,"","","",1,null,"",3961162.3376623383,"","",""]
[null,"PCF172","EXIT-CF-189","Local","Urban West","ITHACA HALL BUILDING",56000,1300,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":114500},1300,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":3325974.0259740264},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N55,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},3440474.0259740264,"","","","","y",null,"","","","",1,1,null,"","","","",3440474.0259740264]
[null,"PCF54","EXIT-CF-192","District","Urban North","SANDGATE & DISTRICT MEALS ON WHEELS INC.",56000,1000,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":101000},1000,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":2558441.5584415589},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N56,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},2659441.5584415589,"","","y","","",null,"","",1,"","",1,null,"","",2659441.5584415589,"",""]
[null,"PCF311","EXIT-CF-193","District","Urban South","INALA COMMUNITY HOUSE",56000,1800,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":137000},1800,1279.2207792207794,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":2302597.4025974027},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N57,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},2439597.4025974027,"","","","y","",null,"","","",1,"",1,null,"","","",2439597.4025974027,""]
[null,"PCF172","EXIT-CF-194","District","Urban North","Spring Hill Baths",56000,895,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":96275},895,2046.7532467532469,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1831844.1558441559},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N58,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1928119.1558441559,"","","y","","",null,"","",1,"","",1,null,"","",1928119.1558441559,"",""]
[null,"PCF173","EXIT-CF-197","District","Urban North","VALLEY SWIMMING POOL",56000,4559,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":261155},4559,5116.8831168831175,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":23327870.129870132},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N59,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},23589025.129870132,"","","y","","",null,"","",1,"","",1,null,"","",23589025.129870132,"",""]
[null,"PCF133","EXIT-CF-198","Local","Urban North","TOOMBUL SHIRE HALL BUILDING",56000,900,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":96500},900,1176.8831168831171,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1059194.8051948054},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N60,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1155694.8051948054,"","","y","","",null,"","",1,"","",1,null,"","",1155694.8051948054,"",""]
[null,"PCF293","EXIT-CF-199","District","Urban South","SUNNYBANK THEATRE GROUP INC",56000,2700,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":177500},2700,1176.8831168831171,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":3177584.4155844161},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N61,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},3355084.4155844161,"","","","y","",null,"","","",1,"",1,null,"","","",3355084.4155844161,""]
[null,"PCF154","EXIT-CF-200a","Local","Urban North","HAMILTON TOWN HALL BUILDING",56000,600,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":83000},600,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1535064.9350649354},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N62,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1618064.9350649354,"","","y","","",null,"","",1,"","",1,null,"","",1618064.9350649354,"",""]
[null,"PCF154","EXIT-CF-200b","District","Urban North","HAMILTON LIBRARY",56000,400,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":74000},400,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1023376.6233766235},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N63,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1097376.6233766235,"","","y","","",null,"","",1,"","",1,null,"","",1097376.6233766235,"",""]
[null,"PCF211","EXIT-CF-202","Principal","Urban West","INDOOROOPILLY LIBRARY",56000,1700,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":132500},1700,1535.0649350649353,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":2609610.3896103902},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N64,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},2742110.3896103902,"","","","","y",null,"","","","",1,1,null,"","","","",2742110.3896103902]
[null,"PCF177","EXIT-CF-204","District","Urban East","WYNNUM COMMUNITY HALL BUILDING",56000,2400,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":164000},2400,1535.0649350649353,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":3684155.8441558448},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N65,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},3848155.8441558448,"","y","","","",null,"",1,"","","",1,null,"",3848155.8441558448,"","",""]
[null,"PCF255","EXIT-CF-215","District","Urban East","MT GRAVATT EAST SWIMMING POOL",56000,6410,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":344450},6410,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":16399610.389610391},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N66,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},16744060.389610391,"","y","","","",null,"",1,"","","",1,null,"",16744060.389610391,"","",""]
[null,"PCF193","EXIT-CF-225b","Principal","Urban North","BRISBANE POWERHOUSE TURBINE HALl",56000,4000,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":236000},4000,2046.7532467532469,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":8187012.987012988},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N67,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},8423012.987012988,"","","y","","",null,"","",1,"","",1,null,"","",8423012.987012988,"",""]
[null,"PCF193","EXIT-CF-225c","Principal","Urban North","BRISBANE POWERHOUSE",56000,4000,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":236000},4000,2046.7532467532469,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":8187012.987012988},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N68,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},8423012.987012988,"","","y","","",null,"","",1,"","",1,null,"","",8423012.987012988,"",""]
[null,"PCF191","EXIT-CF-228","District","Urban West","TOOWONG LIBRARY",56000,1000,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":101000},1000,1535.0649350649353,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1535064.9350649354},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N69,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1636064.9350649354,"","","","","y",null,"","","","",1,1,null,"","","","",1636064.9350649354]
[null,"PCF173","EXIT-CF-243a","District","Urban North","VISIBLE INK",56000,1100,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":105500},1100,5116.8831168831175,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":5628571.4285714291},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N70,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},5734071.4285714291,"","","y","","",null,"","",1,"","",1,null,"","",5734071.4285714291,"",""]
[null,"PCF173","EXIT-CF-243b","Local","Urban North","Maida Lilley Community Centre",56000,1100,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":105500},1100,5116.8831168831175,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":5628571.4285714291},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N71,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},5734071.4285714291,"","","y","","",null,"","",1,"","",1,null,"","",5734071.4285714291,"",""]
[null,"PCF171","EXIT-CF-247","District","Urban West","ASHGROVE LIBRARY",56000,1700,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":132500},1700,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":4349350.6493506497},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N72,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},4481850.6493506497,"","","","","y",null,"","","","",1,1,null,"","","","",4481850.6493506497]
[null,"PCF213","EXIT-CF-252a","Local","Urban South","ANNERLEY HALL BUILDING",56000,2200,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":155000},2200,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":5628571.4285714291},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N73,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},5783571.4285714291,"","","","y","",null,"","","",1,"",1,null,"","","",5783571.4285714291,""]
[null,"PCF213","EXIT-CF-252b","District","Urban South","ANNERLEY LIBRARY",56000,1000,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":101000},1000,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":2558441.5584415589},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N74,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},2659441.5584415589,"","","","y","",null,"","","",1,"",1,null,"","","",2659441.5584415589,""]
[null,"PCF274","EXIT-CF-253","Principal","Urban East","GARDEN CITY LIBRARY",56000,1960,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":144200},1960,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":5014545.4545454551},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N75,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},5158745.4545454551,"","y","","","",null,"",1,"","","",1,null,"",5158745.4545454551,"","",""]
[null,"PCF113","EXIT-CF-261c","Principal","Urban North","CHERMSIDE LIBRARY",56000,3000,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":191000},3000,255.84415584415586,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":767532.46753246756},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N76,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},958532.46753246756,"","","y","","",null,"","",1,"","",1,null,"","",958532.46753246756,"",""]
[null,"PCF152","EXIT-CF-262","Local","Urban North","GRANGE COMMUNITY HALL",56000,1000,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":101000},1000,1692.0371002815923,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1692037.1002815922},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N77,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},{"$f":"J77+M77","v":1793037.1002815922},"","","y","","",null,"","",1,"","",1,null,"","",1793037.1002815922,"",""]
[null,"PCF273","EXIT-CF-263","District","Urban South","Sunnybank Community Centre",56000,6600,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":353000},6600,1692.0371002815923,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":11167444.861858509},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N78,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},11520444.861858509,"","","","y","",null,{"$f":"IF(Q78=\"y\",100%,\"\")","v":""},{"$f":"IF(R78=\"y\",100%,\"\")","v":""},{"$f":"IF(S78=\"y\",100%,\"\")","v":""},{"$f":"IF(T78=\"y\",100%,\"\")","v":1},{"$f":"IF(U78=\"y\",100%,\"\")","v":""},{"$f":"SUM(W78:AA78)","v":1},null,{"$f":"IF(W78=\"\",\"\",(W78/$AB78)*$P78)","v":""},{"$f":"IF(X78=\"\",\"\",(X78/$AB78)*$P78)","v":""},{"$f":"IF(Y78=\"\",\"\",(Y78/$AB78)*$P78)","v":""},{"$f":"IF(Z78=\"\",\"\",(Z78/$AB78)*$P78)","v":11520444.861858509},{"$f":"IF(AA78=\"\",\"\",(AA78/$AB78)*$P78)","v":""}]
[null,"PCF193","EXIT-CF-280","District","Urban South","BRISBANE JAZZ CLUB INC",56000,600,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":83000},600,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1535064.9350649354},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N79,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1618064.9350649354,"","","","y","",null,"","","",1,"",1,null,"","","",1618064.9350649354,""]
[null,"PCF212","EXIT-CF-312","District","Urban South","LINK VISION INC.",56000,3600,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":218000},3600,1895.1418951418955,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":6822510.8225108236},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N80,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},7040510.8225108236,"","","","y","",null,"","","",1,"",1,null,"","","",7040510.8225108236,""]
[null,"PCF34","EXIT-CF-340","District","Urban North","SISTERS OF THE GOOD SAMARITAN FOUNDATION LTD.",56000,800,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":92000},800,1228.0519480519481,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":982441.5584415585},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N81,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1074441.5584415584,"","","y","","",null,"","",1,"","",1,null,"","",1074441.5584415584,"",""]
[null,"PCF73","EXIT-CF-344","District","Urban North","KOOBARA ABORIGINAL & ISLANDER FAMILY RESOURCE CENTRE INC.",56000,19600,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":938000},19600,1228.0519480519481,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":24069818.181818184},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N82,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},25007818.181818184,"","","y","","",null,"","",1,"","",1,null,"","",25007818.181818184,"",""]
[null,"PCF213","EXIT-CF-351","District","Urban South","MULTICULTURAL DEVELOPMENT ASSOCIATION INC.",56000,2500,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":168500},2500,1893.2467532467535,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":4733116.8831168842},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N83,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},4901616.8831168842,"","","","y","",null,"","","",1,"",1,null,"","","",4901616.8831168842,""]
[null,"PCF209","EXIT-CF-390b","District","Urban West","SHED WEST COMMUNITY MEN'S SHED INC.",56000,600,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":83000},600,1404.4420071291474,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":842665.20427748852},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N84,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},925665.20427748852,"","","","","y",null,"","","","",1,1,null,"","","","",925665.20427748852]
[null,"PCF133","EXIT-CF-400","District","Urban North","Scouts Association",56000,700,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":87500},700,1705.6277056277058,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":1193939.393939394},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N85,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},1281439.393939394,"","","y","","",null,"","",1,"","",1,null,"","",1281439.393939394,"",""]
[null,"PCF92","EXIT-CF-410","District","Urban North","Kindergarten",56000,1600,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":128000},1600,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":4093506.493506494},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N86,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},4221506.493506494,"","","y","","",null,"","",1,"","",1,null,"","",4221506.493506494,"",""]
[null,"PCF132","EXIT-CF-419","District","Urban North","Kindergarten",56000,1200,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":110000},1200,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":3070129.8701298707},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N87,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},3180129.8701298707,"","","y","","",null,"","",1,"","",1,null,"","",3180129.8701298707,"",""]
[null,"PCF254","EXIT-CF-442","District","Urban East","Hibiscus Gardens Youth Space",56000,400,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":74000},400,1228.0519480519481,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":491220.77922077925},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N88,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},565220.77922077919,"","y","","","",null,"",1,"","","",1,null,"",565220.77922077919,"","",""]
[null,"PCF171","EXIT-CF-443","District","Urban West","Hands on Art Inc.",56000,100,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":60500},100,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":255844.15584415587},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N89,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},316344.15584415587,"","","","","y",null,"","","","",1,1,null,"","","","",316344.15584415587]
[null,"PCF270","EXIT-CF-444","District","Urban South","Rotary Club of Jindalee Inc.",56000,100,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":60500},100,2558.4415584415588,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":255844.15584415587},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N90,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},316344.15584415587,"","","","y","",null,"","","",1,"",1,null,"","","",316344.15584415587,""]
[null,"PCF192","EXIT-CF-445","District","Urban North","MacArthur Museum Brisbane",56000,500,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":78500},500,12280.519480519482,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":6140259.7402597414},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N91,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},6218759.7402597414,"","","y","","",null,"","",1,"","",1,null,"","",6218759.7402597414,"",""]
[null,"PCF192","EXIT-CF-456","District","Urban North","Brisbane School of Arts",56000,1000,45,{"$f":"Table156[[#This Row],[Construction Unit Rate ($/m)]]*Table156[[#This Row],[Area size (m2)]]+Table156[[#This Row],[Utility allowance ($56,000/site)]]","v":101000},1000,12280.519480519482,{"$f":"Table156[[#This Row],[Land Unit Rate ($/m2)]]*Table156[[#This Row],[Size of land (m2) (*)]]","v":12280519.480519483},2021,{"$f":"IFERROR(('General Input Sheet'!$G$38/(VLOOKUP(N92,'General Input Sheet'!$E$38:$G$48,3,FALSE))),1)","v":1},12381519.480519483,"","","y","","",null,"","",1,"","",1,null,"","",12381519.480519483,"",""]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J13:J92)","v":14135790},null,null,{"$f":"SUM(M12:M92)","v":697347051.57812774},null,null,{"$f":"SUM(P13:P92)","v":711482841.57812774}]

{"sheet":"Future Trunk Assets - LFCF","index":3,"n_rows":28,"n_cols":53,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,41,10,45],[1,1,1,9],[2,1,2,9],[4,1,4,9],[8,1,8,2],[6,4,6,17],[6,1,6,3],[10,28,10,32],[11,43,12,43],[11,44,12,44],[11,45,12,45],[11,34,12,34],[11,35,12,35],[11,36,12,36],[11,37,12,37],[11,38,12,38],[11,39,12,39],[11,41,12,41],[11,42,12,42],[10,47,10,52],[11,52,12,52],[11,47,12,47],[11,48,12,48],[11,49,12,49],[11,50,12,50],[11,51,12,51],[11,29,12,29],[11,30,12,30],[11,31,12,31],[11,32,12,32],[11,1,11,5],[11,6,11,9],[11,10,11,16],[11,17,11,26],[11,28,12,28]]}
[]
[null,{"$f":"'Navigation Pane'!B2","v":"Brisbane City Council"}]
[null,"Parks and Land for Community Facilities"]
["Return to \"Future Trunk Assets\""]
[null,"Future Trunk Assets"]
[]
[null,"Data References",null,null,"1. Project costs are on costs to undertake detailed design, survey, geotechnical investigations, project management, and supervision of construction works and obtain certification from a Registered Professional Engineer of Queensland. Project costs equate to 23% of the direct construction costs.\n2. Contingency costs are based on the project delivery date, and applied to the direct construction cost, and project cost. Contingencies equate to 7.5% for projects with a delivery date up to 2024, 15% for projects with a delivery date up to 2029 and 20% for projects with a delivery date up to 2034.\n3. Total embellishment cost is the sum of direct embellishment cost, indirect embellishment cost, project cost and construction contingency cost. \n4. Terminal Value Adjustment is only applicable to items that have an estimated completion date between 2026 and 2036, items value exceeds 20% of the total network value in the same catchment and same year of provision, and items catchment has spare capacity greater than 30%."]
[]
[null,"Land Valuation Type",null,"Location"]
[]
[null,null,null,null,null,null,null,null,null,null,"Asset Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Catchment Asset Allocation",null,null,null,null,null,null,"Asset Usage",null,null,null,null,null,"Cost Allocation based on Net Present Value of Establishment Cost",null,null,null,null,null,"Cost Allocation for Service Cost Schedule"]
[null,"Basic Asset Data",null,null,null,null,"Land Cost Valuation",null,null,null,null,null,null,null,null,null,null,"Refined Asset Value",null,null,null,null,null,null,null,null,null,null,"Fringe","Urban East","Urban North","Urban South","Urban West",null,{"$f":"AC12","v":"Fringe"},{"$f":"AD12","v":"Urban East"},{"$f":"AE12","v":"Urban North"},{"$f":"AF12","v":"Urban South"},{"$f":"AG12","v":"Urban West"},"TOTALS",null,{"$f":"AC12","v":"Fringe"},{"$f":"AD12","v":"Urban East"},{"$f":"AE12","v":"Urban North"},{"$f":"AF12","v":"Urban South"},{"$f":"AG12","v":"Urban West"},null,{"$f":"AC12","v":"Fringe"},{"$f":"AD12","v":"Urban East"},{"$f":"AE12","v":"Urban North"},{"$f":"AF12","v":"Urban South"},{"$f":"AG12","v":"Urban West"},{"$f":"AN12","v":"TOTALS"}]
[null,"Asset ID","LGIP ID","Hierarchy/Name","Service Catchment","Description","Land Location/Type","Size of Land (m2)","Land Unit Rate ($/m2)","Land Value","Direct Construction Cost","Valuation Year","Multiplier","Construction Contingency Rate %","Construction Contingency Cost ($)","Project Owners Cost (23% Direct Construction Cost)($)","Total Construction Cost ($)","Year of Provision","Land Cost Escalation","Work Cost Escalation","Spare Capacity (%)","Share of the total Cost with the same year of provision %","Terminal Value Analysis","Terminal Value Adjustment (%)","Establishment Cost","Establishment Cost (Escalated)","Net Present Value of Establishment Cost","NPV Establishment Cost after Terminal Value Adjustment","Fringe","Urban East","Urban North","Urban South","Urban West"]
[null,"Councils ID (from GIS, FAR, AMA etc.)","ID from the LGIP drawings","Local/District Park",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable to project year of provision at 2024",null,null," % of cost which is relevant for Summary Cost Calculation",null,"Gross cost (used for CF forecasts)","Adjusted Current Day Value ","For Summary Cost Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AV15:AV27)","v":1304045.3355978848},{"$f":"SUM(AW15:AW27)","v":19344796.713860381},{"$f":"SUM(AX15:AX27)","v":33846801.37515381},{"$f":"SUM(AY15:AY27)","v":27797698.939172618},{"$f":"SUM(AZ15:AZ27)","v":17005367.636215311}]
[null,"PCF154","EAF-CF-001","District","Urban North","Land acquisition, basic site preparation and connection to services to provide DISTRICT COMMUNITY HUB",null,6000,{"$f":"J15/H15","v":1862.4676666666667},11174806,459210.12375610624,2021,1,{"$f":"IF(R15=\"\",\"\",IF(R15<=YEAR+5,0.075,IF(AND(R15>YEAR+5,R15<=YEAR+10),0.15,IF(AND(R15>YEAR+10,R15<=YEAR+20),0.2,IF(R15>YEAR+20,0.25,\"\")))))","v":0.15},{"$f":"(K15+P15)*N15","v":84724.21856341594},{"$f":"ROUND((K15)*23%,0)","v":105618},{"$f":"ROUND((K15+P15+(K15+P15)*N15),0)","v":649552},2029,{"$f":"Landind","v":2.0111853187589457E-2},{"$f":"PPI","v":1.8200000000000001E-2},{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2024,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":0.24825665082274484},{"$f":"_xlfn.IFS(FutureTrunkParks[[#This Row],[Year of Provision]]=2024,0,FutureTrunkParks[[#This Row],[Year of Provision]]=2029,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,2029,E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]),FutureTrunkParks[[#This Row],[Year of Provision]]=2034,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,\"2034\",E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]))","v":1},{"$f":"IF(AND(FutureTrunkParks[[#This Row],[Spare Capacity (%)]]>30%,FutureTrunkParks[[#This Row],[Share of the total Cost with the same year of provision %]]>20%),(1-FutureTrunkParks[[#This Row],[Spare Capacity (%)]]),1)","v":1},{"$f":"IF(FutureTrunkParks[[#This Row],[Terminal Value Analysis]]<0,0,FutureTrunkParks[[#This Row],[Terminal Value Analysis]])","v":1},{"$f":"ROUND((Q15+J15),0)","v":11824358},{"$f":"ROUND((Q15*(1+T15)^(R15-YEAR)+J15*(1+S15)^(R15-YEAR)),0)","v":13854933},{"$f":"ROUND((Z15*(1/(1+WACC))^(R15-YEAR)),0)","v":8752028},{"$f":"FutureTrunkParks[[#This Row],[Net Present Value of Establishment Cost]]*FutureTrunkParks[[#This Row],[Terminal Value Adjustment (%)]]","v":8752028},"Y","Y","Y","Y","Y",null,1.3729607286742941E-2,0.20367118739886947,0.31089128801268717,0.29266734789935012,0.17904056940235033,{"$f":"SUM(AI15:AM15)","v":1},null,{"$f":"IF(AI15=\"\",\"\",(AI15/$AN15)*$AA15)","v":120161.90740257825},{"$f":"IF(AJ15=\"\",\"\",(AJ15/$AN15)*$AA15)","v":1782535.9349081528},{"$f":"IF(AK15=\"\",\"\",(AK15/$AN15)*$AA15)","v":2720929.2576431027},{"$f":"IF(AL15=\"\",\"\",(AL15/$AN15)*$AA15)","v":2561432.8235008535},{"$f":"IF(AM15=\"\",\"\",(AM15/$AN15)*$AA15)","v":1566968.0765453135},null,{"$f":"IF(AI15=\"\",\"\",(AI15/$AN15)*$AB15)","v":120161.90740257825},{"$f":"IF(AJ15=\"\",\"\",(AJ15/$AN15)*$AB15)","v":1782535.9349081528},{"$f":"IF(AK15=\"\",\"\",(AK15/$AN15)*$AB15)","v":2720929.2576431027},{"$f":"IF(AL15=\"\",\"\",(AL15/$AN15)*$AB15)","v":2561432.8235008535},{"$f":"IF(AM15=\"\",\"\",(AM15/$AN15)*$AB15)","v":1566968.0765453135},{"$f":"SUM(AV15:AZ15)","v":8752028}]
[null,"PCF131","EVP-CF-001","District","Urban North","Basic site preparation and connection to services to provide DISTRICT LIBRARY EXTENSION",null,5000,367.00599999999997,1835030,426412.03220553632,2021,1,7.4999999999999997E-2,39336.527415415221,98075,563824,2024,2.0111853187589457E-2,1.8200000000000001E-2,{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2024,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":""},{"$f":"_xlfn.IFS(FutureTrunkParks[[#This Row],[Year of Provision]]=2024,0,FutureTrunkParks[[#This Row],[Year of Provision]]=2029,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,2029,E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]),FutureTrunkParks[[#This Row],[Year of Provision]]=2034,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,\"2034\",E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]))","v":0},{"$f":"IF(AND(FutureTrunkParks[[#This Row],[Spare Capacity (%)]]>30%,FutureTrunkParks[[#This Row],[Share of the total Cost with the same year of provision %]]>20%),(1-FutureTrunkParks[[#This Row],[Spare Capacity (%)]]),1)","v":1},{"$f":"IF(FutureTrunkParks[[#This Row],[Terminal Value Analysis]]<0,0,FutureTrunkParks[[#This Row],[Terminal Value Analysis]])","v":1},2398854,2543162,2140736,{"$f":"FutureTrunkParks[[#This Row],[Net Present Value of Establishment Cost]]*FutureTrunkParks[[#This Row],[Terminal Value Adjustment (%)]]","v":2140736},"Y","Y","Y","Y","Y",null,1.3729607286742941E-2,0.20367118739886947,0.31089128801268717,0.29266734789935012,0.17904056940235033,1,null,29391.464584592937,436006.24302750622,665536.17233512783,626523.52767266321,383278.59238010983,null,29391.464584592937,436006.24302750622,665536.17233512783,626523.52767266321,383278.59238010983,2140736]
[null,"PCF291","INA-CF-002","District","Urban South","Basic site preparation and connection to services to provide DISTRICT COMMUNITY HUB",null,2000,1023.3765,2046753,299280.96001447435,2021,1,0.2,73623.192002894866,68835,441739,2034,2.0111853187589457E-2,1.8200000000000001E-2,{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2024,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":0.22198657080249576},{"$f":"_xlfn.IFS(FutureTrunkParks[[#This Row],[Year of Provision]]=2024,0,FutureTrunkParks[[#This Row],[Year of Provision]]=2029,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,2029,E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]),FutureTrunkParks[[#This Row],[Year of Provision]]=2034,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,\"2034\",E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]))","v":1},{"$f":"IF(AND(FutureTrunkParks[[#This Row],[Spare Capacity (%)]]>30%,FutureTrunkParks[[#This Row],[Share of the total Cost with the same year of provision %]]>20%),(1-FutureTrunkParks[[#This Row],[Spare Capacity (%)]]),1)","v":1},{"$f":"IF(FutureTrunkParks[[#This Row],[Terminal Value Analysis]]<0,0,FutureTrunkParks[[#This Row],[Terminal Value Analysis]])","v":1},2488492,3209935,1521653,{"$f":"FutureTrunkParks[[#This Row],[Net Present Value of Establishment Cost]]*FutureTrunkParks[[#This Row],[Terminal Value Adjustment (%)]]","v":1521653},"Y","Y","Y","Y","Y",null,1.3729607286742941E-2,0.20367118739886947,0.31089128801268717,0.29266734789935012,0.17904056940235033,1,null,20891.698116694257,309916.87331905193,473068.66107836948,445338.14793308981,272437.61955279461,null,20891.698116694257,309916.87331905193,473068.66107836948,445338.14793308981,272437.61955279461,1521653]
[null,"PCF310","INA-CF-003","District","Urban South","Land acquisition, basic site preparation and connection to services to provide DISTRICT INTEGRATED FACILITY",null,12000,64.688333333333333,776260,1028083.8545322957,2021,1,0.15,189681.42817984437,236459,1454224,2029,2.0111853187589457E-2,1.8200000000000001E-2,{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2024,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":0.22198657080249576},{"$f":"_xlfn.IFS(FutureTrunkParks[[#This Row],[Year of Provision]]=2024,0,FutureTrunkParks[[#This Row],[Year of Provision]]=2029,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,2029,E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]),FutureTrunkParks[[#This Row],[Year of Provision]]=2034,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,\"2034\",E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]))","v":3.7815399307372211E-2},{"$f":"IF(AND(FutureTrunkParks[[#This Row],[Spare Capacity (%)]]>30%,FutureTrunkParks[[#This Row],[Share of the total Cost with the same year of provision %]]>20%),(1-FutureTrunkParks[[#This Row],[Spare Capacity (%)]]),1)","v":1},{"$f":"IF(FutureTrunkParks[[#This Row],[Terminal Value Analysis]]<0,0,FutureTrunkParks[[#This Row],[Terminal Value Analysis]])","v":1},2230484,2590259,1636242,{"$f":"FutureTrunkParks[[#This Row],[Net Present Value of Establishment Cost]]*FutureTrunkParks[[#This Row],[Terminal Value Adjustment (%)]]","v":1636242},"Y","Y","Y","Y","Y",null,1.3729607286742941E-2,0.20367118739886947,0.31089128801268717,0.29266734789935012,0.17904056940235033,1,null,22464.960086074843,333255.35101190099,508693.38288045529,478874.60666152841,292953.69936004048,null,22464.960086074843,333255.35101190099,508693.38288045529,478874.60666152841,292953.69936004048,1636242]
[null,"PCF211","IND-CF-001","District","Urban West","Land acquisition, basic site preparation and connection to services to provide DISTRICT COMMUNITY HUB",null,2000,0,0,363321.108377058,2021,1,7.4999999999999997E-2,33516.383128279347,83564,480401,2024,2.0111853187589457E-2,1.8200000000000001E-2,{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2024,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":""},{"$f":"_xlfn.IFS(FutureTrunkParks[[#This Row],[Year of Provision]]=2024,0,FutureTrunkParks[[#This Row],[Year of Provision]]=2029,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,2029,E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]),FutureTrunkParks[[#This Row],[Year of Provision]]=2034,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,\"2034\",E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]))","v":0},{"$f":"IF(AND(FutureTrunkParks[[#This Row],[Spare Capacity (%)]]>30%,FutureTrunkParks[[#This Row],[Share of the total Cost with the same year of provision %]]>20%),(1-FutureTrunkParks[[#This Row],[Spare Capacity (%)]]),1)","v":1},{"$f":"IF(FutureTrunkParks[[#This Row],[Terminal Value Analysis]]<0,0,FutureTrunkParks[[#This Row],[Terminal Value Analysis]])","v":1},480401,507111,426867,{"$f":"FutureTrunkParks[[#This Row],[Net Present Value of Establishment Cost]]*FutureTrunkParks[[#This Row],[Terminal Value Adjustment (%)]]","v":426867},"Y","Y","Y","Y","Y",null,1.3729607286742941E-2,0.20367118739886947,0.31089128801268717,0.29266734789935012,0.17904056940235033,1,null,5860.7162736700993,86940.508751393209,132709.23144011173,124930.03279575189,76426.510739073085,null,5860.7162736700993,86940.508751393209,132709.23144011173,124930.03279575189,76426.510739073085,426867]
[null,"PCF131","MIT-CF-001","District","Urban West","Land acquisition, basic site preparation and connection to services to provide DISTRICT INTEGRATED FACILITY",null,11800,1428,16850400,509751.99583861034,2021,1,0.15,94049.249375791551,117243,721044,2029,2.0111853187589457E-2,1.8200000000000001E-2,{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2024,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":0.13526120073940345},{"$f":"_xlfn.IFS(FutureTrunkParks[[#This Row],[Year of Provision]]=2024,0,FutureTrunkParks[[#This Row],[Year of Provision]]=2029,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,2029,E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]),FutureTrunkParks[[#This Row],[Year of Provision]]=2034,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,\"2034\",E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]))","v":1},{"$f":"IF(AND(FutureTrunkParks[[#This Row],[Spare Capacity (%)]]>30%,FutureTrunkParks[[#This Row],[Share of the total Cost with the same year of provision %]]>20%),(1-FutureTrunkParks[[#This Row],[Spare Capacity (%)]]),1)","v":1},{"$f":"IF(FutureTrunkParks[[#This Row],[Terminal Value Analysis]]<0,0,FutureTrunkParks[[#This Row],[Terminal Value Analysis]])","v":1},17571444,20593220,13008539,{"$f":"FutureTrunkParks[[#This Row],[Net Present Value of Establishment Cost]]*FutureTrunkParks[[#This Row],[Terminal Value Adjustment (%)]]","v":13008539},"Y","Y","Y","Y","Y",null,1.3729607286742941E-2,0.20367118739886947,0.31089128801268717,0.29266734789935012,0.17904056940235033,1,null,178602.13184427973,2649464.584454502,4044241.4448732734,3807174.6091752639,2329056.2296526809,null,178602.13184427973,2649464.584454502,4044241.4448732734,3807174.6091752639,2329056.2296526809,13008539]
[null,"PCF174","MOR-CF-001","District","Urban East","Land acquisition, basic site preparation and connection to services to provide AQUATIC CENTRE EXTENSION",null,2000,2558.4414999999999,5116883,427496.70544599229,2021,1,0.15,78873.105816898838,98324,604694,2029,2.0111853187589457E-2,1.8200000000000001E-2,{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2024,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":0.21362881937309328},{"$f":"_xlfn.IFS(FutureTrunkParks[[#This Row],[Year of Provision]]=2024,0,FutureTrunkParks[[#This Row],[Year of Provision]]=2029,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,2029,E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]),FutureTrunkParks[[#This Row],[Year of Provision]]=2034,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,\"2034\",E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]))","v":0.34682181169783949},{"$f":"IF(AND(FutureTrunkParks[[#This Row],[Spare Capacity (%)]]>30%,FutureTrunkParks[[#This Row],[Share of the total Cost with the same year of provision %]]>20%),(1-FutureTrunkParks[[#This Row],[Spare Capacity (%)]]),1)","v":1},{"$f":"IF(FutureTrunkParks[[#This Row],[Terminal Value Analysis]]<0,0,FutureTrunkParks[[#This Row],[Terminal Value Analysis]])","v":1},5721577,6699060,4231732,{"$f":"FutureTrunkParks[[#This Row],[Net Present Value of Establishment Cost]]*FutureTrunkParks[[#This Row],[Terminal Value Adjustment (%)]]","v":4231732},"Y","Y","Y","Y","Y",null,1.3729607286742941E-2,0.20367118739886947,0.31089128801268717,0.29266734789935012,0.17904056940235033,1,null,58100.018502743282,861881.88119379268,1315608.6120045048,1238489.7814608128,757651.70683814678,null,58100.018502743282,861881.88119379268,1315608.6120045048,1238489.7814608128,757651.70683814678,4231732]
[null,"PCF275","ROC-CF-002","Local","Urban East","Land acquisition, basic site preparation and connection to services to provide LOCAL COMMUNITY CENTRE",null,2000,771.68700000000001,1543374,417076.9073638501,2021,1,0.15,76950.736104577518,95928,589956,2029,2.0111853187589457E-2,1.8200000000000001E-2,{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2024,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":0.21362881937309328},{"$f":"_xlfn.IFS(FutureTrunkParks[[#This Row],[Year of Provision]]=2024,0,FutureTrunkParks[[#This Row],[Year of Provision]]=2029,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,2029,E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]),FutureTrunkParks[[#This Row],[Year of Provision]]=2034,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,\"2034\",E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]))","v":0.12931493809300337},{"$f":"IF(AND(FutureTrunkParks[[#This Row],[Spare Capacity (%)]]>30%,FutureTrunkParks[[#This Row],[Share of the total Cost with the same year of provision %]]>20%),(1-FutureTrunkParks[[#This Row],[Spare Capacity (%)]]),1)","v":1},{"$f":"IF(FutureTrunkParks[[#This Row],[Terminal Value Analysis]]<0,0,FutureTrunkParks[[#This Row],[Terminal Value Analysis]])","v":1},2133330,2491425,1573809,{"$f":"FutureTrunkParks[[#This Row],[Net Present Value of Establishment Cost]]*FutureTrunkParks[[#This Row],[Terminal Value Adjustment (%)]]","v":1573809},"Y","Y","Y","Y","Y",null,1.3729607286742941E-2,0.20367118739886947,0.31089128801268717,0.29266734789935012,0.17904056940235033,1,null,21607.779514341622,320539.54776902735,489283.50709595921,460602.50613012828,281775.65949054359,null,21607.779514341622,320539.54776902735,489283.50709595921,460602.50613012828,281775.65949054359,1573809.0000000002]
[null,"PCF192","SBR-CF-001","Principal","Urban South","Land acquisition, basic site preparation and connection to services to provide PRINCIPAL INDOOR SPORTS CENTRE",null,20000,2558.44155,51168831,660602.8454857968,2021,1,0.15,121881.27682286952,151939,934423,2029,2.0111853187589457E-2,1.8200000000000001E-2,{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2024,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":0.22198657080249576},{"$f":"_xlfn.IFS(FutureTrunkParks[[#This Row],[Year of Provision]]=2024,0,FutureTrunkParks[[#This Row],[Year of Provision]]=2029,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,2029,E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]),FutureTrunkParks[[#This Row],[Year of Provision]]=2034,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,\"2034\",E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]))","v":0.88335327902977046},{"$f":"IF(AND(FutureTrunkParks[[#This Row],[Spare Capacity (%)]]>30%,FutureTrunkParks[[#This Row],[Share of the total Cost with the same year of provision %]]>20%),(1-FutureTrunkParks[[#This Row],[Spare Capacity (%)]]),1)","v":1},{"$f":"IF(FutureTrunkParks[[#This Row],[Terminal Value Analysis]]<0,0,FutureTrunkParks[[#This Row],[Terminal Value Analysis]])","v":1},52103254,61084520,38586503,{"$f":"FutureTrunkParks[[#This Row],[Net Present Value of Establishment Cost]]*FutureTrunkParks[[#This Row],[Terminal Value Adjustment (%)]]","v":38586503},"Y","Y","Y","Y","Y",null,1.3729607286742941E-2,0.20367118739886947,0.31089128801268717,0.29266734789935012,0.17904056940235033,1,null,529777.53275872837,7858958.8835800393,11996207.617575418,11293009.497720316,6908549.4683654988,null,529777.53275872837,7858958.8835800393,11996207.617575418,11293009.497720316,6908549.4683654988,38586503]
[null,"PCF211","TOO-CF-002","District","Urban West","Land acquisition, basic site preparation and connection to services to provide DISTRICT AQUATIC CENTRE",null,10000,1895.1419000000001,18951419,1844954.4143296541,2021,1,0.2,453858.88286593085,424340,2723153,2034,2.0111853187589457E-2,1.8200000000000001E-2,{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2024,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":0.13526120073940345},{"$f":"_xlfn.IFS(FutureTrunkParks[[#This Row],[Year of Provision]]=2024,0,FutureTrunkParks[[#This Row],[Year of Provision]]=2029,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,2029,E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]),FutureTrunkParks[[#This Row],[Year of Provision]]=2034,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,\"2034\",E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]))","v":1},{"$f":"IF(AND(FutureTrunkParks[[#This Row],[Spare Capacity (%)]]>30%,FutureTrunkParks[[#This Row],[Share of the total Cost with the same year of provision %]]>20%),(1-FutureTrunkParks[[#This Row],[Spare Capacity (%)]]),1)","v":1},{"$f":"IF(FutureTrunkParks[[#This Row],[Terminal Value Analysis]]<0,0,FutureTrunkParks[[#This Row],[Terminal Value Analysis]])","v":1},21674572,27993378,13270116,{"$f":"FutureTrunkParks[[#This Row],[Net Present Value of Establishment Cost]]*FutureTrunkParks[[#This Row],[Terminal Value Adjustment (%)]]","v":13270116},"Y","Y","Y","Y","Y",null,1.3729607286742941E-2,0.20367118739886947,0.31089128801268717,0.29266734789935012,0.17904056940235033,1,null,182193.4813295241,2702740.2826407361,4125563.4553177683,3883729.6560367323,2375889.1246752394,null,182193.4813295241,2702740.2826407361,4125563.4553177683,3883729.6560367323,2375889.1246752394,13270116]
[null,"PCF254","UMG-CF-001","District","Urban East","Land acquisition, basic site preparation and connection to services to provide AQUATIC CENTRE EXTENSION",null,3000,2558.4416666666666,7675325,683586.86556902458,2021,1,0.15,126121.77983535368,157225,966934,2029,2.0111853187589457E-2,1.8200000000000001E-2,{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2024,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":0.21362881937309328},{"$f":"_xlfn.IFS(FutureTrunkParks[[#This Row],[Year of Provision]]=2024,0,FutureTrunkParks[[#This Row],[Year of Provision]]=2029,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,2029,E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]),FutureTrunkParks[[#This Row],[Year of Provision]]=2034,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,\"2034\",E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]))","v":0.52386325020915714},{"$f":"IF(AND(FutureTrunkParks[[#This Row],[Spare Capacity (%)]]>30%,FutureTrunkParks[[#This Row],[Share of the total Cost with the same year of provision %]]>20%),(1-FutureTrunkParks[[#This Row],[Spare Capacity (%)]]),1)","v":1},{"$f":"IF(FutureTrunkParks[[#This Row],[Terminal Value Analysis]]<0,0,FutureTrunkParks[[#This Row],[Terminal Value Analysis]])","v":1},8642259,10117780,6391304,{"$f":"FutureTrunkParks[[#This Row],[Net Present Value of Establishment Cost]]*FutureTrunkParks[[#This Row],[Terminal Value Adjustment (%)]]","v":6391304},"Y","Y","Y","Y","Y",null,1.3729607286742941E-2,0.20367118739886947,0.31089128801268717,0.29266734789935012,0.17904056940235033,1,null,87750.093970189308,1301724.4747071441,1987000.7326406396,1870525.9912985079,1144302.7073835193,null,87750.093970189308,1301724.4747071441,1987000.7326406396,1870525.9912985079,1144302.7073835193,6391304]
[null,"PCF192","WES-CF-001","District","Urban South","Land acquisition, basic site preparation and connection to services to provide LOCAL COMMUNITY CENTRE AND LIBRARY EXTENSION",null,1800,2411,4339800,219120.24841686263,2021,1,0.15,40427.737262529394,50398,309946,2029,2.0111853187589457E-2,1.8200000000000001E-2,{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2024,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":0.22198657080249576},{"$f":"_xlfn.IFS(FutureTrunkParks[[#This Row],[Year of Provision]]=2024,0,FutureTrunkParks[[#This Row],[Year of Provision]]=2029,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,2029,E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]),FutureTrunkParks[[#This Row],[Year of Provision]]=2034,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,\"2034\",E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]))","v":7.8831321662857348E-2},{"$f":"IF(AND(FutureTrunkParks[[#This Row],[Spare Capacity (%)]]>30%,FutureTrunkParks[[#This Row],[Share of the total Cost with the same year of provision %]]>20%),(1-FutureTrunkParks[[#This Row],[Spare Capacity (%)]]),1)","v":1},{"$f":"IF(FutureTrunkParks[[#This Row],[Terminal Value Analysis]]<0,0,FutureTrunkParks[[#This Row],[Terminal Value Analysis]])","v":1},4649746,5447286,3440998,{"$f":"FutureTrunkParks[[#This Row],[Net Present Value of Establishment Cost]]*FutureTrunkParks[[#This Row],[Terminal Value Adjustment (%)]]","v":3440998},"Y","Y","Y","Y","Y",null,1.3729607286742941E-2,0.20367118739886947,0.31089128801268717,0.29266734789935012,0.17904056940235033,1,null,47243.551214467887,700832.14849713503,1069776.3002690806,1007067.758786968,616078.24123234872,null,47243.551214467887,700832.14849713503,1069776.3002690806,1007067.758786968,616078.24123234872,3440998]
[null,"PCF153","WSR-CF-001","Local","Urban North","Land acquisition, basic site preparation and connection to services to provide LOCAL COMMUNITY CENTRE",null,1800,2454,4417200,315830.62475122121,2021,1,7.4999999999999997E-2,29135.37185634159,72641,417607,2024,2.0111853187589457E-2,1.8200000000000001E-2,{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2024,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":""},{"$f":"_xlfn.IFS(FutureTrunkParks[[#This Row],[Year of Provision]]=2024,0,FutureTrunkParks[[#This Row],[Year of Provision]]=2029,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,2029,E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]),FutureTrunkParks[[#This Row],[Year of Provision]]=2034,FutureTrunkParks[[#This Row],[Establishment Cost]]/SUMIFS(Y$15:Y$27,R$15:R$27,\"2034\",E$15:E$27,FutureTrunkParks[[#This Row],[Service Catchment]]))","v":0},{"$f":"IF(AND(FutureTrunkParks[[#This Row],[Spare Capacity (%)]]>30%,FutureTrunkParks[[#This Row],[Share of the total Cost with the same year of provision %]]>20%),(1-FutureTrunkParks[[#This Row],[Spare Capacity (%)]]),1)","v":1},{"$f":"IF(FutureTrunkParks[[#This Row],[Terminal Value Analysis]]<0,0,FutureTrunkParks[[#This Row],[Terminal Value Analysis]])","v":1},4834807,5129936,4318183,{"$f":"FutureTrunkParks[[#This Row],[Net Present Value of Establishment Cost]]*FutureTrunkParks[[#This Row],[Terminal Value Adjustment (%)]]","v":4318183},{"$f":"IF(AC$13=$E27,\"Y\",\"\")","v":""},"","Y","","",null,{"$f":"IF(AC27=\"Y\",100%,\"\")","v":""},{"$f":"IF(AD27=\"Y\",100%,\"\")","v":""},{"$f":"IF(AE27=\"Y\",100%,\"\")","v":1},{"$f":"IF(AF27=\"Y\",100%,\"\")","v":""},{"$f":"IF(AG27=\"Y\",100%,\"\")","v":""},1,null,"","",4318183,"","",null,"","",4318183,"","",4318183]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(FutureTrunkParks[[#This Row],[Year of Provision]]>2019,VLOOKUP(FutureTrunkParks[[#This Row],[Service Catchment]],'Catchment Demand - LFCF'!$C$8:$M$12,11,FALSE),\"\"),\"\")","v":""},null,null,null,{"$f":"SUBTOTAL(109,FutureTrunkParks[Establishment Cost])","v":136753578},{"$f":"SUBTOTAL(109,FutureTrunkParks[Establishment Cost (Escalated)])","v":162262005},{"$f":"SUBTOTAL(109,FutureTrunkParks[Net Present Value of Establishment Cost])","v":99298710},{"$f":"SUBTOTAL(109,FutureTrunkParks[NPV Establishment Cost after Terminal Value Adjustment])","v":99298710}]

{"sheet":"Catchment Demand - LFCF","index":4,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,11],[2,1,2,11],[4,1,4,11]]}
[]
[null,{"$f":"'Navigation Pane'!B2","v":"Brisbane City Council"}]
[null,"Land for Community Facilities"]
["Return to \"Catchment Demand\""]
[null,"Catchment Demand(equivalent persons)"]
[]
[null,"Catchment No","Catchment Name (*)",2021,2026,2031,2036,2041,null,{"$f":"\"NPV Future Demand (\"&(D7+1)& \" - \" &G7&\")\"","v":"NPV Future Demand (2022 - 2036)"},null,{"$f":" \"Ultimate Demand\"","v":"Ultimate Demand"},"Spare Capacity"]
[null,1,"Fringe",20937,20814,20639,21323,21245,null,{"$f":"NPV(5.91%,E43:S43)","v":110.52772693513626},null,21928,{"$f":"(L8-G8)/G8","v":2.8373118229142239E-2}]
[null,2,"Urban East",281926,291638,301216,316315,331019,null,{"$f":"NPV(5.91%,E44:S44)","v":21453.687649975127},null,383889,{"$f":"(L9-G9)/G9","v":0.21362881937309328}]
[null,3,"Urban North",396666,429284,456967,482835,508114,null,57395.040332076213,null,602702,0.24825665082274484]
[null,4,"Urban South",385242,404589,426593,454532,486037,null,43572.935734573439,null,555432,0.22198657080249576]
[null,5,"Urban West",255491,262389,268953,278062,287882,null,14318.056580818058,null,315673,0.13526120073940345]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Totals",{"$f":"SUM(D8:D37)","v":1340262},{"$f":"SUM(E8:E37)","v":1408714},{"$f":"SUM(F8:F37)","v":1474368},{"$f":"SUM(G8:G37)","v":1553067},{"$f":"SUM(H8:H37)","v":1634297},null,{"$f":"SUM(J8:J37)","v":136850.24802437797},null,{"$f":"SUM(L8:L37)","v":1879624}]
[]
[]
[null,"DETAILED Forecast Demand Growth Profile (OPTIONAL)"]
[null,"Catchment No","Catchment Name",2021,{"$f":"D42 +1","v":2022},{"$f":"E42 +1","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041]
[null,{"$f":"B8","v":1},{"$f":"C8","v":"Fringe"},null,{"$f":"($E8-$D8)/5","v":-24.6},{"$f":"($E8-$D8)/5","v":-24.6},{"$f":"($E8-$D8)/5","v":-24.6},{"$f":"($E8-$D8)/5","v":-24.6},{"$f":"($E8-$D8)/5","v":-24.6},{"$f":"($F8-$E8)/5","v":-35},{"$f":"($F8-$E8)/5","v":-35},{"$f":"($F8-$E8)/5","v":-35},{"$f":"($F8-$E8)/5","v":-35},{"$f":"($F8-$E8)/5","v":-35},{"$f":"($G8-$F8)/5","v":136.80000000000001},{"$f":"($G8-$F8)/5","v":136.80000000000001},{"$f":"($G8-$F8)/5","v":136.80000000000001},{"$f":"($G8-$F8)/5","v":136.80000000000001},{"$f":"($G8-$F8)/5","v":136.80000000000001},{"$f":"($H8-$G8)/5","v":-15.6},{"$f":"($H8-$G8)/5","v":-15.6},{"$f":"($H8-$G8)/5","v":-15.6},{"$f":"($H8-$G8)/5","v":-15.6},{"$f":"($H8-$G8)/5","v":-15.6}]
[null,{"$f":"B9","v":2},"Urban East",null,{"$f":"($E9-$D9)/5","v":1942.4},1942.4,{"$f":"($E9-$D9)/5","v":1942.4},1942.4,1942.4,{"$f":"($F9-$E9)/5","v":1915.6},1915.6,{"$f":"($F9-$E9)/5","v":1915.6},1915.6,{"$f":"($F9-$E9)/5","v":1915.6},{"$f":"($G9-$F9)/5","v":3019.8},{"$f":"($G9-$F9)/5","v":3019.8},3019.8,3019.8,3019.8,{"$f":"($H9-$G9)/5","v":2940.8},2940.8,{"$f":"($H9-$G9)/5","v":2940.8},2940.8,2940.8]
[null,3,"Urban North",null,6523.6,6523.6,{"$f":"($E10-$D10)/5","v":6523.6},6523.6,6523.6,5536.6,5536.6,{"$f":"($F10-$E10)/5","v":5536.6},5536.6,{"$f":"($F10-$E10)/5","v":5536.6},5173.6000000000004,{"$f":"($G10-$F10)/5","v":5173.6000000000004},5173.6000000000004,5173.6000000000004,5173.6000000000004,5055.8,5055.8,{"$f":"($H10-$G10)/5","v":5055.8},5055.8,5055.8]
[null,4,"Urban South",null,3869.4,3869.4,{"$f":"($E11-$D11)/5","v":3869.4},3869.4,3869.4,4400.8,4400.8,{"$f":"($F11-$E11)/5","v":4400.8},4400.8,{"$f":"($F11-$E11)/5","v":4400.8},5587.8,{"$f":"($G11-$F11)/5","v":5587.8},5587.8,5587.8,5587.8,6301,6301,{"$f":"($H11-$G11)/5","v":6301},6301,6301]
[null,5,"Urban West",null,1379.6,1379.6,{"$f":"($E12-$D12)/5","v":1379.6},1379.6,1379.6,1312.8,1312.8,{"$f":"($F12-$E12)/5","v":1312.8},1312.8,{"$f":"($F12-$E12)/5","v":1312.8},1821.8,{"$f":"($G12-$F12)/5","v":1821.8},1821.8,1821.8,1821.8,1964,1964,{"$f":"($H12-$G12)/5","v":1964},1964,1964]

{"sheet":"Summary Cost Schedule","index":5,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[8,1,8,9],[1,1,1,9],[2,1,2,9],[4,1,4,9],[6,3,6,5],[6,6,6,8],[6,1,6,2],[6,9,7,9]]}
[]
[null,{"$f":"'Navigation Pane'!B2","v":"Brisbane City Council"}]
[]
["Return to Navigation Pane"]
[null,"Summary Cost Schedule"]
[]
[null,"Catchment",null,"Demand",null,null,"Cost of Trunk Infrastrcutrue ",null,null,"Cost per Unit Demand (Average)"]
[null,"No","Name","Existing (A)","NPV Future (B)","TOTAL (A)+ (B)","Existing (C)","NPV Future (D)","TOTAL (C)+ (D)"]
[null,"Land for Community Facilities"]
[null,{"$f":"'Catchment Demand - LFCF'!B43","v":1},{"$f":"'Catchment Demand - LFCF'!C43","v":"Fringe"},{"$f":"IFERROR(VLOOKUP($C10,'Catchment Demand - LFCF'!$C$8:$J$37,2,FALSE),\"\")","v":20937},{"$f":"IFERROR(VLOOKUP($C10,'Catchment Demand - LFCF'!$C$8:$J$37,8,FALSE),\"\")","v":110.52772693513626},{"$f":"IFERROR(D10+E10,\"\")","v":21047.527726935135},{"$f":"HLOOKUP(C10,'Existing Trunk Assets - LFCF'!$AD$9:$AH$12,4,FALSE)","v":0},{"$f":"HLOOKUP(C10,'Future Trunk Assets - LFCF'!$AV$12:$AZ$14,3,FALSE)","v":1304045.3355978848},{"$f":"G10+H10","v":1304045.3355978848},{"$f":"IFERROR(I10/F10,0)","v":61.957173902617548}]
[null,{"$f":"'Catchment Demand - LFCF'!B44","v":2},{"$f":"'Catchment Demand - LFCF'!C44","v":"Urban East"},{"$f":"IFERROR(VLOOKUP($C11,'Catchment Demand - LFCF'!$C$8:$J$37,2,FALSE),\"\")","v":281926},{"$f":"IFERROR(VLOOKUP($C11,'Catchment Demand - LFCF'!$C$8:$J$37,8,FALSE),\"\")","v":21453.687649975127},{"$f":"IFERROR(D11+E11,\"\")","v":303379.68764997512},{"$f":"HLOOKUP(C11,'Existing Trunk Assets - LFCF'!$AD$9:$AH$12,4,FALSE)","v":73946878.701298699},{"$f":"HLOOKUP(C11,'Future Trunk Assets - LFCF'!$AV$12:$AZ$14,3,FALSE)","v":19344796.713860381},{"$f":"G11+H11","v":93291675.415159076},{"$f":"IFERROR(I11/F11,0)","v":307.50798162464497}]
[null,{"$f":"'Catchment Demand - LFCF'!B45","v":3},{"$f":"'Catchment Demand - LFCF'!C45","v":"Urban North"},{"$f":"IFERROR(VLOOKUP($C12,'Catchment Demand - LFCF'!$C$8:$J$37,2,FALSE),\"\")","v":396666},{"$f":"IFERROR(VLOOKUP($C12,'Catchment Demand - LFCF'!$C$8:$J$37,8,FALSE),\"\")","v":57395.040332076213},454061.0403320762,{"$f":"HLOOKUP(C12,'Existing Trunk Assets - LFCF'!$AD$9:$AH$12,4,FALSE)","v":509010309.09162354},{"$f":"HLOOKUP(C12,'Future Trunk Assets - LFCF'!$AV$12:$AZ$14,3,FALSE)","v":33846801.37515381},542857110.46677732,1195.5597645412615]
[null,{"$f":"'Catchment Demand - LFCF'!B46","v":4},{"$f":"'Catchment Demand - LFCF'!C46","v":"Urban South"},{"$f":"IFERROR(VLOOKUP($C13,'Catchment Demand - LFCF'!$C$8:$J$37,2,FALSE),\"\")","v":385242},{"$f":"IFERROR(VLOOKUP($C13,'Catchment Demand - LFCF'!$C$8:$J$37,8,FALSE),\"\")","v":43572.935734573439},428814.93573457346,{"$f":"HLOOKUP(C13,'Existing Trunk Assets - LFCF'!$AD$9:$AH$12,4,FALSE)","v":93917782.282226384},{"$f":"HLOOKUP(C13,'Future Trunk Assets - LFCF'!$AV$12:$AZ$14,3,FALSE)","v":27797698.939172618},121715481.22139901,283.84151548475467]
[null,{"$f":"'Catchment Demand - LFCF'!B47","v":5},{"$f":"'Catchment Demand - LFCF'!C47","v":"Urban West"},{"$f":"IFERROR(VLOOKUP($C14,'Catchment Demand - LFCF'!$C$8:$J$37,2,FALSE),\"\")","v":255491},{"$f":"IFERROR(VLOOKUP($C14,'Catchment Demand - LFCF'!$C$8:$J$37,8,FALSE),\"\")","v":14318.056580818058},269809.05658081808,{"$f":"HLOOKUP(C14,'Existing Trunk Assets - LFCF'!$AD$9:$AH$12,4,FALSE)","v":34607871.502978802},{"$f":"HLOOKUP(C14,'Future Trunk Assets - LFCF'!$AV$12:$AZ$14,3,FALSE)","v":17005367.636215311},51613239.139194116,191.29542867562708]
[null,null,"Totals",{"$f":"SUM(D10:D14)","v":1340262},136850.24802437797,1477112.248024378,711482841.57812738,99298710.000000015,810781551.5781275,2040.1618642289059]